SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_UpdateRecruitmentParticipants_apply]

	(
	@param_id int,
	@param_recruitment INT,
	@param_employing_unit INT,
	@param_booth_quantity Int,
	@param_booth_arrange NVarChar(MAX),
	@param_remark_recruitment NVarChar(MAX),
	@param_contactperson NVarChar(50),
	@param_mobile NVarChar(50),
	@param_email NVarChar(50),
	@param_phone NVarChar(50),
	@param_fax NVarChar(50),
	@param_is_payment Bit,
	@param_is_need_invoice Bit,
	@param_invoice_beginning NVarChar(50),
	@param_invoice_item NVarChar(50),
	@param_update_time smalldatetime,
	@param_user_update NVarChar(50),
	@param_state Bit,
	@param_user_check NVarChar(50),
	@param_remark_invoice NVarChar(50),
	@param_is_visible bit
	)

AS
	/* SET NOCOUNT ON */
	update dbo.JOL_Recruitment_Participants_apply
	set
	 recruitment=@param_recruitment,
	 employing_unit=@param_employing_unit,
	 booth_quantity=@param_booth_quantity,
	 booth_arrange=@param_booth_arrange ,
	 remark_recruitment=@param_remark_recruitment ,
	 contactperson=@param_contactperson ,
	 mobile=@param_mobile ,
	 email=@param_email ,
	 phone=@param_phone,
	 fax=@param_fax,
	 is_payment=@param_is_payment,
	 is_need_invoice=@param_is_need_invoice,
	 invoice_beginning =@param_invoice_beginning,
	 invoice_item=@param_invoice_item,
	 update_time=@param_update_time ,
	 user_update=@param_user_update,
	 state=@param_state,
	 user_check=@param_user_check,
	 remark_invoice=@param_remark_invoice,
	 is_visible=@param_is_visible
	 where 
	 id=@param_id
	

	RETURN
GO
